﻿<!DOCTYPE html>
<html>
	<head>
		<title>Protect ranges</title>
		<meta charset="utf-8" />
		<meta name="description" content="Protecting ranges to prevent the unwanted changes and to restrict the editing abilities of other users" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
			<div class="search-field">
				<input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
			</div>

			<h1>Protect ranges</h1>
			<p>The <b>Protect Range</b> option allows you to specify cell ranges that cannot be edited by users without corresponding editing rights that are granted by the creator of the file or a user with full access to it.</p>
			<p>To select a range of locked cells a user will be allowed to change:</p>
			<ol>
				<li>
					Click the <b>Protect Range</b> button on the top toolbar of the <b>Protection</b> tab. The <b>Protected Ranges</b> window will open.
					<p><img alt="Edit Ranges" src="../images/editranges.png" /></p>
				</li>
				<li>Use the <b>Filter</b> drop-down list to choose the required sheet. Click the <b>New</b> button in the <b>Protected Ranges</b> window to select and add a range of cells a user will be allowed to edit.</li>
				<li>
					In the <b>New Range</b> window, type the range <b>Title</b>, and select the range of cells by clicking the <b>Select Range</b> button. Select users <b>who can edit</b> this range and click <b>OK</b> to confirm.
					<p><img alt="New Range" src="../images/allowedit_newrange.png" /></p>
				</li>
				<li>To edit or delete a range, select it in the <b>Protected Ranges</b> window and click the <b>Edit</b> or <b>Delete</b> button accordingly.</li>
				<li>Click the <b>Close</b> button in the <b>Protected Ranges</b> window when you are ready.</li>
			</ol>
			<p>To learn more about allowing edit ranges, please refer to the <a href="../UsageInstructions/ProtectSheet.htm" onclick="onhyperlinkclick(this)">following article</a>.</p>
		</div>
	</body>
</html>